<?php if(!defined('PATH_HD'))exit;
$db->exe("DROP TABLE IF EXISTS `hd_user`");
$db->exe("CREATE TABLE `hd_user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `username` char(30) NOT NULL COMMENT '用户名',
  `password` char(40) NOT NULL COMMENT '密码',
  `nickname` char(20) NOT NULL COMMENT '呢称',
  `qq` char(12) NOT NULL COMMENT 'QQ号',
  `sex` enum('男','女','保密') NOT NULL DEFAULT '保密' COMMENT '性别',
  `email` varchar(45) NOT NULL COMMENT '邮箱',
  `regip` char(15) NOT NULL COMMENT '注册ip地址',
  `loginip` char(15) NOT NULL COMMENT '最后登录ip地址',
  `logintime` int(10) NOT NULL COMMENT '	',
  `regtime` int(10) NOT NULL COMMENT '注册时间',
  `tel` varchar(45) NOT NULL COMMENT '电话',
  `mobile` varchar(45) NOT NULL COMMENT '手机\n',
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `adminstyle` varchar(10) DEFAULT 'style1',
  PRIMARY KEY (`uid`),
  KEY `username` (`username`),
  KEY `password` (`password`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='用户表\n'");
$db->exe('REPLACE INTO `hd_user`(`uid`,`username`,`password`,`nickname`,`qq`,`sex`,`email`,`regip`,`loginip`,`logintime`,`regtime`,`tel`,`mobile`,`state`,`adminstyle`)VALUES ("15","admin","202cb962ac59075b964b07152d234b70","","","保密","","","127.0.0.1","1350895217","0","","","1","style2")');
$db->exe('REPLACE INTO `hd_user`(`uid`,`username`,`password`,`nickname`,`qq`,`sex`,`email`,`regip`,`loginip`,`logintime`,`regtime`,`tel`,`mobile`,`state`,`adminstyle`)VALUES ("22","徐卫兵","202cb962ac59075b964b07152d234b70","","123456789","保密","xwb7724@126.com","","127.0.0.1","1350892096","0","","15861667623","1","style1")');

?>